

package com.gc.server.service.impl;
import org.springframework.transaction.annotation.Transactional;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.alibaba.excel.EasyExcel;
import com.alibaba.fastjson.JSON;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import  com.gc.server.vo.down.DayOffDown;

import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.io.IOException;
import java.net.URLEncoder;
import com.gc.server.vo.down.DayOffDown;
import javax.servlet.http.HttpServletResponse;
import java.util.stream.Collectors;
import com.gc.server.dao.DayOffDao;
import com.gc.server.entity.DayOffEntity;
import com.gc.server.vo.DayOffVo;
import com.gc.server.service.DayOffService;
import com.yf.service.impl.BaseServiceImpl;

/**
 * 账户记录Service实现类
 *
 * @author hxf
 * @email 505860922@qq.com
 * @date Thu Oct 22 09:16:32 CST 2020
 */
@Service
public class DayOffServiceImpl extends BaseServiceImpl<DayOffEntity> implements DayOffService {

    private DayOffDao dao;


    @Autowired
    public void setDao(DayOffDao dao) {
        this.dao = dao;
        super.setBaseDao(dao);
    }




    @Override
    public List<DayOffVo> findVo(DayOffVo vo){
        return dao.findVo(vo);
    }

    @Override
    public DayOffVo getVo(Long id){
        return dao.getVo(id);
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public int saveVo(DayOffVo vo){
        return dao.save(vo.getEntity());
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public int updateVo(DayOffVo vo){
        return dao.update(vo.getEntity());
    }



    @Override
    public void downLoad(HttpServletResponse response, List<DayOffVo> list) {
        try {
            List<DayOffDown> datas = list.stream().map(item -> new DayOffDown(item)).collect(Collectors.toList());
            response.setContentType("application/vnd.ms-excel" );
            response.setCharacterEncoding("utf-8" );
            // 这里URLEncoder.encode可以防止中文乱码 当然和easyexcel没有关系
            String fileName = URLEncoder.encode("测试", "UTF-8" );
            response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx" );
            EasyExcel.write(response.getOutputStream(), DayOffDown.class).sheet("模板" ).doWrite(datas);
        } catch (Exception e) {
            e.printStackTrace();
        }

    }




    /**内部方法**/



    /**外部方法实现**/

    @Override
    public List<DayOffEntity> findByDate(Date start, Date end) {
        return dao.findByDate(start,end);
    }
}
